Are postgreSQL views UPDATEable?

Hello,

Found this snippet in a postgreSQL GENERAL posting:

>Ross J. Reedstrom <reedstrm@rice.edu> wrote
>
>Eric -
>I've redirected your question to the general list, since it seems to fit
>in there better than the sql list.  I think you're confusing mySQL's
>limitations with those of PostgreSQL (PG from here on) - PG does in fact
>support views, has for quite a while. They're even updateable.
                                                    ^^^^^^^^^^^
What exactly does this mean?

Does you can INSERT into a view with tuples being inserted into the base
table(s) accordingly?

Does it mean you can UPDATE values in the views and values in the base
table(s) will be accordingly modified?

I have tried both and have not got either of these to work, even on single
base tables views.

I'm running PG 6.4.0.

regards,

Stuart.


+-------------------------+--------------------------------------+
| Stuart Rison            | Ludwig Institute for Cancer Research |
+-------------------------+ 91 Riding House Street               |
| Tel. (0171) 878 4041    | London, W1P 8BT, UNITED KINGDOM.     |
| Fax. (0171) 878 4040    | stuart@ludwig.ucl.ac.uk              |
+-------------------------+--------------------------------------+